

mod1 <- fixest::feols(avg_score_democ_support ~ pre_post*validated_election_outcome, data = estimation_data %>% filter(appointed == 0), cluster = ~ID)
mod2 <- fixest::feols(avg_score_trust_elect ~ pre_post*validated_election_outcome, data = estimation_data %>% filter(appointed == 0), cluster = ~ID)

mod3 <- fixest::feols(avg_score_democ_support ~ pre_post*validated_election_outcome, data = estimation_data %>% filter(appointed == 1), cluster = ~ID)
mod4 <- fixest::feols(avg_score_trust_elect ~ pre_post*validated_election_outcome, data = estimation_data %>% filter(appointed == 1), cluster = ~ID)

mods <- list(mod1, mod2, mod3, mod4)

table_df <-
  modelsummary(mods,
               stars = c("*" = 0.1, "**" = 0.05, "***" = 0.01),
               coef_map = c(
                 "pre_post" = "Post Election",
                 "validated_election_outcomeNot Elected" = "Outcome: Lost",
                 "pre_post:validated_election_outcomeNot Elected" = "Post x Lost"
               ),
               gof_map = c("nobs", "r.squared"),
               output = "data.frame"
  ) %>%
  mutate(term = ifelse(statistic == "std.error", "", term)) %>%
  select(-c(part, statistic)) %>%
  mutate_all(as.character)


# Append the new row to the table
latex_table <-
  table_df %>%
  kableExtra::kable("latex",
                    booktabs = T,
                    longtable = T,
                    escape = F,
                    cap = "\\label{tab:bupati}Main Analysis, by Bupati Appointment Status",
                    padding = 0,
                    col.names = linebreak(c("", "(1)", "(2)", "(3)", "(4)"), c("l", rep("c", 4))),
                    align = c("l", rep("c", 4)),
                    linesep = "") %>%
  kableExtra::row_spec(6, hline_after = T) %>%
  kableExtra::kable_styling(
    font_size = 9,
    latex_options = c("scale_down",
                      "hold_position",
                      "striped")) %>%
  
  kableExtra::add_header_above(
    header = c(
      " " = 1,
      "Supp. for Dem." = 1,
      "Trust in Elec." = 1,
      "Supp. for Dem." = 1,
      "Trust in Elec." = 1
    ),
    align = c("l", rep("c", 4))
  ) %>%
  kableExtra::add_header_above(
    header = c(
      " " = 1,
      "Bupati: Elected" = 2,
      "Bupati: Appointed" = 2
    ),
    align = c("l", rep("c", 4))
  )

cat("\\renewcommand{\\arraystretch}{0.9}\n", file = "./outputs/tables/table_a16.tex")
cat(latex_table, file = "./outputs/tables/table_a16.tex", append = TRUE)

